<?php

require_once($_SERVER['DOCUMENT_ROOT'].'/mpd/config/config.php');

							include ('../../config/config.php');
							//include ('../../view/spm/reviewpekerjaan.php');
								$q = mysql_query("SELECT b.NAMA as Nama, b.NIP as NIP ,count(p.ID_PEKERJAAN) as 'Jumlah Pekerjaan' FROM pekerjaan as p INNER JOIN biodata as b ON p.NIP = b.NIP WHERE b.ID_DEPARTEMEN = '" . $_SESSION['ID_DEPARTEMEN'] ."' GROUP BY p.NIP");
?>